﻿IF EXISTS (SELECT * from sys.procedures p left join sys.schemas s on p.schema_id = s.schema_id where p.name='connector_update' and s.name='Meta')
DROP PROCEDURE [Meta].connector_update
GO
CREATE PROCEDURE [Meta].connector_update 
@PK uniqueidentifier, 
@Type nvarchar(50), 
@Login nvarchar(100), 
@Password nvarchar(100), 
@Params nvarchar(500)
AS
BEGIN
UPDATE [Meta].[Connectors] 
SET	[type] = @Type ,
	[login] = @Login ,
	[password] = @Password ,
	[params] = @Params 
WHERE
	[id_connector] = @PK 
END